<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Contents</title>
<link type="text/css" href="../../skin/page.css" rel="stylesheet">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<!--================= start Navigation Path ==================-->
<table summary="navigation path" width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td nowrap="nowrap" valign="middle" bgcolor="#CFDCED" height="20"><img height="1" width="5" alt="" src="../../skin/images/spacer.gif" class="spacer"><!--===== breadcrumb trail (javascript-generated) ====--><font size="2" face="Arial, Helvetica, Sans-serif"><script src="../../skin/breadcrumbs.js" language="JavaScript" type="text/javascript"></script></font></td>
</tr>
<tr>
<td bgcolor="#4C6C8F" height="2"><img height="2" width="2" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
</table>
<!--================= end Navigation Path ==================-->
<!--================= start Banner ==================-->
<table summary="header with logos" width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<!--================= start Group Logo ==================-->
<td bgcolor="#294563"><a href="http://incubator.apache.org"><img border="0" class="logoImage" alt="" src="../../resources/images/apache-incubator.png" title="Derby is a zero admin java based embedded database."></a></td>
<!--================= end Group Logo ==================-->
<!--================= start Project Logo ==================--><td width="100%" align="center" bgcolor="#294563"><a href="http://incubator.apache.org/derby/"><img border="0" class="logoImage" alt="Derby" src="../../images/derby-logo.jpg" title="Derby is a zero admin java based embedded database."></a></td>
<!--================= end Project Logo ==================-->
<!--================= start Search ==================--><td valign="top" rowspan="2" bgcolor="#294563">
<form target="_blank" action="http://www.google.com/search" method="get">
<table summary="search" border="0" cellspacing="0" cellpadding="0" bgcolor="#4C6C8F">
<tr>
<td colspan="3"><img height="10" width="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td><img height="1" width="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td nowrap="nowrap"><input value="incubator.apache.org" name="sitesearch" type="hidden"><input size="15" name="q" id="query" type="text"><img height="1" width="5" alt="" src="../../skin/images/spacer.gif" class="spacer"><input name="Search" value="Search" type="submit">
<br>
<font face="Arial, Helvetica, Sans-serif" size="2" color="white">
                      the Derby site
                      
                      
                    </font></td><td><img height="1" width="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td><img alt="" border="0" height="10" width="9" src="../../skin/images/search-left.gif"></td><td><img height="1" width="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td><img alt="" border="0" height="10" width="9" src="../../skin/images/search-right.gif"></td>
</tr>
</table>
</form>
</td>
<!--================= start Search ==================--><td bgcolor="#294563"><img height="10" width="10" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td valign="bottom" bgcolor="#294563" colspan="2">
<!--================= start Tabs ==================-->
<div class="tab">
<table summary="tab bar" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="6"><img alt="" height="8" width="6" src="../../skin/images/spacer.gif"></td><td valign="bottom">
<table summary="non selected tab" style="height: 1.6em" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" width="5" bgcolor="#B2C4E0"><img height="5" width="5" alt="" src="../../skin/images/tab-left.gif"></td><td valign="middle" bgcolor="#B2C4E0"><a class="base-not-selected" href="../../index.html">Home</a></td><td valign="top" width="5" bgcolor="#B2C4E0"><img height="5" width="5" alt="" src="../../skin/images/tab-right.gif"></td>
</tr>
<tr>
<td colspan="3" height="1"></td>
</tr>
</table>
</td><td width="6"><img alt="" height="8" width="6" src="../../skin/images/spacer.gif"></td><td valign="bottom">
<table summary="selected tab" style="height: 1.8em" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" width="5" bgcolor="#4C6C8F"><img height="5" width="5" alt="" src="../../skin/images/tabSel-left.gif"></td><td valign="middle" bgcolor="#4C6C8F"><font color="#ffffff" size="2" face="Arial, Helvetica, Sans-serif"><b><a class="base-selected" href="../../manuals/index.html">Manuals</a></b></font></td><td valign="top" width="5" bgcolor="#4C6C8F"><img height="5" width="5" alt="" src="../../skin/images/tabSel-right.gif"></td>
</tr>
</table>
</td><td width="6"><img alt="" height="8" width="6" src="../../skin/images/spacer.gif"></td><td valign="bottom">
<table summary="non selected tab" style="height: 1.6em" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" width="5" bgcolor="#B2C4E0"><img height="5" width="5" alt="" src="../../skin/images/tab-left.gif"></td><td valign="middle" bgcolor="#B2C4E0"><a class="base-not-selected" href="../../papers/index.html">Papers</a></td><td valign="top" width="5" bgcolor="#B2C4E0"><img height="5" width="5" alt="" src="../../skin/images/tab-right.gif"></td>
</tr>
<tr>
<td colspan="3" height="1"></td>
</tr>
</table>
</td>
</tr>
</table>
</div>
<!--================= end Tabs ==================-->
</td><td bgcolor="#294563"><img alt="" width="1" height="1" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td bgcolor="#4C6C8F" colspan="4"><img width="1" height="10" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
</table>
<!--================= end Banner ==================-->
<!--================= start Menu, NavBar, Content ==================-->
<table summary="page content" bgcolor="#ffffff" width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top">
<table summary="menu" border="0" cellspacing="0" cellpadding="0">
<tr>
<!--================= start left top NavBar ==================-->
<td rowspan="3" valign="top">
<table summary="blue line" border="0" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#294563"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td bgcolor="#CFDCED"><font color="#4C6C8F" size="4" face="Arial, Helvetica, Sans-serif">&nbsp;</font></td>
</tr>
<tr>
<td bgcolor="#294563"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
</table>
</td>
<!--================= end left top NavBar ==================--><td bgcolor="#294563"><img width="1" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td valign="bottom" bgcolor="#4C6C8F"><img width="10" height="10" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td nowrap="nowrap" valign="top" bgcolor="#4C6C8F">
<!--================= start Menu items ==================-->
<div class="menu">
<ul>
<li>
<font color="#CFDCED">Manuals</font>
<ul>
     
<li>
<a href="../../manuals/index.html">About</a>
</li>
     
<li>
<font color="#CFDCED">Getting Started</font>
<ul>
         
<li>
<a href="../../manuals/getstart/gspr02.html" title="Table of Contents">Table of Contents</a>
</li>
         
<li>
<a href="../../manuals/getstart/gspr40.html" title="Index">Index</a>
</li>
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
     
</ul>
</li>
     
<li>
<font color="#CFDCED">Reference Manual</font>
<ul>
         
<li>
<a href="../../manuals/reference/sqlj02.html" title="Table of Contents">Table of Contents</a>
</li>
         
<li>
<a href="../../manuals/reference/sqlj275.html" title="Index">Index</a>
</li>
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
     
</ul>
</li>

     
<li>
<font color="#CFDCED">Developer's Guide</font>
<ul>
         
<li>
<span class="sel"><font color="#ffcc00">Table of Contents</font></span>
</li>
         
<li>
<a href="../../manuals/develop/develop157.html" title="Index">Index</a>
</li>
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
     
</ul>
</li>
     
<li>
<font color="#CFDCED">Tuning Derby</font>
<ul>
         
<li>
<a href="../../manuals/tuning/perf02.html" title="Table of Contents">Table of Contents</a>
</li>
         
<li>
<a href="../../manuals/tuning/perf121.html" title="Index">Index</a>
</li>
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
     
</ul>
</li>

     
<li>
<font color="#CFDCED">Server &amp; Admin Guide</font>
<ul>
         
<li>
<a href="../../manuals/admin/hubprnt02.html" title="Table of Contents">Table of Contents</a>
</li>
         
<li>
<a href="../../manuals/admin/hubprnt65.html" title="Index">Index</a>
</li>
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
        
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
    
</ul>
</li>

    
<li>
<font color="#CFDCED">Tools &amp; Utility Guide</font>
<ul>
         
<li>
<a href="../../manuals/tools/tools02.html" title="Table of Contents">Table of Contents</a>
</li>
         
<li>
<a href="../../manuals/tools/tools113.html" title="Index">Index</a>
</li>
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
    
</ul>
</li>
  
</ul>
</li>
</ul>
</div>
<!--================= end Menu items ==================-->
</td><td valign="bottom" bgcolor="#4C6C8F"><img width="10" height="10" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td bgcolor="#294563"><img width="1" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td valign="bottom" align="left" colspan="2" rowspan="2" bgcolor="#4C6C8F"><img height="10" width="10" border="0" alt="" src="../../skin/images/menu-left.gif"></td><td bgcolor="#4C6C8F"><img height="10" width="10" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td valign="bottom" align="right" colspan="2" rowspan="2" bgcolor="#4C6C8F"><img height="10" width="10" border="0" alt="" src="../../skin/images/menu-right.gif"></td>
</tr>
<tr>
<td height="1" bgcolor="#294563"><img width="1" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
</table>
</td><td valign="top" width="100%">
<table summary="content" width="100%" border="0" cellpadding="0" cellspacing="0">
<!--================= start middle NavBar ==================-->
<tr>
<td colspan="4" bgcolor="#294563"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td align="left" width="10" bgcolor="#CFDCED"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td align="left" width="50%" bgcolor="#CFDCED"><font color="#4C6C8F" size="3" face="Arial, Helvetica, Sans-serif">
                &nbsp;
                
                </font><img width="10" height="8" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td align="right" width="50%" bgcolor="#CFDCED"><font color="#4C6C8F" size="3" face="Arial, Helvetica, Sans-serif">
                &nbsp;
                
                </font><img width="10" height="8" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td width="10" bgcolor="#CFDCED"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td colspan="4" bgcolor="#294563"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<!--================= end middle NavBar ==================-->
<!--================= start Content==================-->
<tr>
<td align="left" width="10"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td colspan="2" align="left" width="100%">
<div class="content">
<table class="title" summary="">
<tr>
<td valign="middle">
<h1>Contents</h1>
</td>
</tr>
</table>
<ul class="minitoc">
<li>
<a href="#Developer%27s+Guide">Developer's Guide</a>
</li>
<li>
<a href="#Contents">Contents</a>
</li>
</ul>
<a name="N10036"></a><a name="Developer%27s+Guide"></a>
<h3>Developer's Guide</h3>
<div style="margin-left: 0 ; border: 2px">
<br>
<hr>
</div>
<a name="N1003C"></a><a name="Contents"></a>
<h3>Contents</h3>
<div style="margin-left: 0 ; border: 2px">
<p>
<a href="develop.html">Copyright</a>
<br>
</p>
<p>
<a href="develop03.html#HDRSII-DGPREF-29520">About This Document</a>
<br>
</p>
<ul>
<li>
<a href="develop04.html#HDRSII-DGPREF-11181">Purpose of This Document</a>
</li>
<li>
<a href="develop05.html#HDRSII-DGPREF-24290">Audience</a>
</li>
<li>
<a href="develop06.html#HDRSII-DGPREF-23947">How This Document Is Organized</a>
</li>
</ul>
<p>
<a href="develop07.html#HDRSII-DEVELOP-19524">JDBC Applications and Derby Basics</a>
<br>
</p>
<ul>
<li>
<a href="develop08.html#HDRSII-DEVELOP-14839">Application Development Overview</a>
</li>
<li>
<a href="develop09.html#HDRSII-DEVELOP-39409">Derby Embedded Basics</a> 
<ul>
<li>
<a href="develop10.html#HDRSII-DEVELOP-40653">Derby JDBC Driver</a>
</li>
<li>
<a href="develop11.html#HDRSII-DEVELOP-17453">Derby JDBC Database Connection URL</a>
</li>
<li>
<a href="develop12.html#HDRSII-DEVELOP-27610">Derby System</a>
</li>
<li>
<a href="develop13.html#HDRSII-DEVELOP-21955">A Derby Database</a>
</li>
<li>
<a href="develop14.html#HDRSII-DEVELOP-34964">Connecting to Databases</a>
</li>
<li>
<a href="develop15.html#HDRSII-DEVELOP-51654">Working with the Database Connection URL Attributes</a>
</li>
</ul>
</li>
</ul>
<p>
<a href="develop16.html#HDRSII-START-19524">After Installing</a>
<br>
</p>
<ul>
<li>
<a href="develop19.html#HDRSII-START-18978">Derby and JVMs</a>
</li>
<li>
<a href="develop20.html#HDRSII-START-98282">Derby Libraries and Class Path</a>
</li>
<li>
<a href="develop21.html#HDRSII-START-41260">UNIX-Specific Issues</a> 
<ul>
<li>
<a href="develop22.html#HDRSII-START-39409">Configuring File Descriptors</a>
</li>
<li>
<a href="develop23.html#HDRSTART813545">Scripts</a>
</li>
</ul>
</li>
</ul>
<p>
<a href="develop24.html#HDRSII-DEVELOP-25174">Derby Embedded Basics</a>
<br>
</p>
<ul>
<li>
<a href="develop25.html#HDRSII-DEVELOP-40170">Embedded Derby JDBC Driver</a>
</li>
<li>
<a href="develop26.html#HDRSII-DEVELOP-38881">Embedded Derby JDBC Database Connection URL</a>
</li>
<li>
<a href="develop27.html#HDRSII-DEVELOP-10252">Getting a Nested Connection</a>
</li>
<li>
<a href="develop28.html#HDRSII-DEVELOP-38381">Starting Derby as an Embedded Database</a>
</li>
</ul>
<p>
<a href="develop29.html#HDRSII-DEPLOY-32171">Deploying Derby Applications</a>
<br>
</p>
<ul>
<li>
<a href="develop30.html#HDRSII-DEPLOY-38918">Deployment Issues</a> 
<ul>
<li>
<a href="develop31.html#HDRDEPLOY855368">Embedded Deployment Application Overview</a>
</li>
<li>
<a href="develop32.html#HDRSII-DEPLOY-37603">Deployment Cheat Sheets</a>
</li>
</ul>
</li>
<li>
<a href="develop33.html#HDRSII-DEPLOY-15325">Creating Derby Databases for Read-Only Use</a> 
<ul>
<li>
<a href="develop34.html#HDRSII-DEPLOY-26887">Creating and Preparing the Database for Read-Only Use</a>
</li>
<li>
<a href="develop35.html#HDRSII-DEPLOY-19136">Deploying the Database on the Read-Only Media</a>
</li>
<li>
<a href="develop36.html#HDRSII-DEPLOY-33704">Transferring Read-Only Databases to Archive (Jar or Zip) Files</a>
</li>
<li>
<a href="develop37.html#HDRSII-DEPLOY-11201">Accessing a Read-Only Database in a Zip/Jar</a>
</li>
<li>
<a href="develop38.html#HDRSII-DEPLOY-39856">Accessing Databases-in-a-Jar in the Class Path</a>
</li>
<li>
<a href="develop39.html#HDRSII-DEPLOY-82529">Databases on Read-Only Media and DatabaseMetaData</a>
</li>
</ul>
</li>
<li>
<a href="develop40.html#HDRSII-DEPLOY-30736">Loading Classes from a Database</a> 
<ul>
<li>
<a href="develop41.html#HDRDEPLOY856753">Class Loading Overview</a>
</li>
<li>
<a href="develop42.html#HDRSII-DEPLOY-15818">Create Jar Files for Your Application</a>
</li>
<li>
<a href="develop43.html#HDRSII-DEPLOY-23812">Add the jar file or files to the database</a>
</li>
<li>
<a href="develop44.html#HDRSII-DEPLOY-21645">Enable database class loading with a property</a>
</li>
<li>
<a href="develop45.html#HDRSII-DEPLOY-12748">Code your applications the way you normally would</a>
</li>
<li>
<a href="develop46.html#HDRSII-DEPLOY-17604">Dynamic Changes to Jar Files or Database Jar Class Path</a>
</li>
</ul>
</li>
</ul>
<p>
<a href="develop47.html#Header_87">Derby server-side programming</a>
<br>
</p>
<ul>
<li>
<a href="develop48.html#HDRSII-SPECIAL-42117">Programming Database-Side JDBC Procedures</a> 
<ul>
<li>
<a href="develop49.html#HDRSII-SPECIAL-27988">Overview</a>
</li>
<li>
<a href="develop50.html#HDRSII-SPECIAL-29620">Database-Side JDBC Procedures and Nested Connections</a>
</li>
<li>
<a href="develop51.html#HDRSII-SPECIAL-16181">Database-Side JDBC Procedures Using Non-Nested Connections</a>
</li>
<li>
<a href="develop52.html#HDRSII-SPECIAL-41728">Database-Side JDBC Procedures and SQLExceptions</a>
</li>
<li>
<a href="develop53.html#HDRSII-SPECIAL-45786">User-Defined SQLExceptions</a>
</li>
</ul>
</li>
<li>
<a href="develop54.html#HDRSII-SPECIAL-27163">Programming Trigger Actions</a> 
<ul>
<li>
<a href="develop55.html#HDRSII-SPECIAL-53165">Trigger Action Overview</a>
</li>
<li>
<a href="develop56.html#HDRSII-SPECIAL-76763">Performing Referential Actions</a>
</li>
<li>
<a href="develop57.html#HDRSII-SPECIAL-67260">Accessing Before and After Rows</a>
</li>
<li>
<a href="develop58.html#HDRSII-SPECIAL-13670">Examples</a>
</li>
<li>
<a href="develop59.html#HDRSII-SPECIAL-49460">Triggers and Exceptions</a>
</li>
</ul>
</li>
</ul>
<p>
<a href="develop60.html#HDRSII-CONCEPTS-19524">Controlling Derby Application Behavior</a>
<br>
</p>
<ul>
<li>
<a href="develop61.html#HDRSII-CONCEPTS-38375">The JDBC Connection and Transaction Model</a> 
<ul>
<li>
<a href="develop62.html#HDRSII-CONCEPTS-36881">Connections</a>
</li>
<li>
<a href="develop63.html#HDRSII-CONCEPTS-19173">Transactions</a>
</li>
</ul>
</li>
<li>
<a href="develop64.html#HDRSII-CONCEPTS-41275">SQL and JDBC ResultSet/Cursor Mechanisms</a> 
<ul>
<li>
<a href="develop65.html#HDRSII-CONCEPTS-88082">Simple Non-Updatable ResultSets</a>
</li>
<li>
<a href="develop66.html#HDRSII-CONCEPTS-28351">Updatable Cursors</a>
</li>
<li>
<a href="develop67.html#HDRSII-CONCEPTS-23987">ResultSets and Auto-Commit</a>
</li>
<li>
<a href="develop68.html#HDRSII-CONCEPTS-22641">Scrolling Insensitive ResultSets</a>
</li>
<li>
<a href="develop69.html#HDRSII-CONCEPTS-HOLDABLECURSORS">Holdable Cursors</a>
</li>
</ul>
</li>
<li>
<a href="develop70.html#HDRSII-CONCEPTS-30291">Locking, Concurrency, and Isolation</a> 
<ul>
<li>
<a href="develop71.html#HDRSII-CONCEPTS-15366">Isolation Levels and Concurrency</a>
</li>
<li>
<a href="develop72.html#HDRSII-CONCEPTS-22300">Configuring Isolation Levels</a>
</li>
<li>
<a href="develop73.html#HDRSII-CONCEPTS-23810">Lock Granularity</a>
</li>
<li>
<a href="develop74.html#HDRSII-CONCEPTS-36402">Types and Scope of Locks in Derby Systems</a>
</li>
<li>
<a href="develop75.html#HDRSII-CONCEPTS-28436">Deadlocks</a>
</li>
</ul>
</li>
<li>
<a href="develop76.html#HDRSII-CONCEPTS-34828">Working with Multiple Connections to a Single Database</a> 
<ul>
<li>
<a href="develop77.html#HDRSII-CONCEPTS-35713">Deployment Options and Threading and Connection Modes</a>
</li>
<li>
<a href="develop78.html#HDRSII-CONCEPTS-10914">Multi-User Database Access</a>
</li>
<li>
<a href="develop79.html#HDRSII-CONCEPTS-24019">Multiple Connections from a Single Application</a>
</li>
</ul>
</li>
<li>
<a href="develop80.html#HDRSII-CONCEPTS-23499">Working with Multiple Threads Sharing a Single Connection</a> 
<ul>
<li>
<a href="develop81.html#HDRSII-CONCEPTS-89498">Pitfalls of Sharing a Connection Among Threads</a>
</li>
<li>
<a href="develop82.html#HDRSII-CONCEPTS-65864">Multi-thread programming tips</a>
</li>
<li>
<a href="develop83.html#HDRSII-CONCEPTS-91600">Threads Sharing a Statement: A Case Study</a>
</li>
</ul>
</li>
<li>
<a href="develop84.html#HDRSII-DEVELOP-22619">Working with Database Threads in an Embedded Environment</a>
</li>
<li>
<a href="develop85.html#HDRSII-CONCEPTS-24927">Working with Derby SQLExceptions in an Application</a> 
<ul>
<li>
<a href="develop86.html#HDRCONCEPTS844813">Information Provided in SQLExceptions</a>
</li>
</ul>
</li>
</ul>
<p>
<a href="develop87.html#HDRSII-RESMAN-19524">Using Derby as a J2EE Resource Manager</a>
<br>
</p>
<ul>
<li>
<a href="develop88.html#HDRSII-RESMAN-79556">The Classes Pertaining to Resource Managers</a>
</li>
<li>
<a href="develop89.html#HDRSII-RESMAN-78715">How to Use Them</a> 
<ul>
<li>
<a href="develop90.html#HDRSII-RESMAN-89722">Getting a DataSource</a>
</li>
<li>
<a href="develop91.html#HDRSII-RESMAN-92946">Shutting Down or Creating a Database</a>
</li>
</ul>
</li>
</ul>
<p>
<a href="develop92.html#Header_161">Derby and Security</a>
<br>
</p>
<ul>
<li>
<a href="develop93.html#HDRSII-CSECUR-33663">Security Overview</a> 
<ul>
<li>
<a href="develop94.html#HDRCSECUR862382">Features</a>
</li>
<li>
<a href="develop95.html#HDRSII-CSECUR-12392">Configuring Security for Your Environment</a>
</li>
</ul>
</li>
<li>
<a href="develop96.html#HDRSII-CSECUR-42374">Working with User Authentication</a> 
<ul>
<li>
<a href="develop97.html#HDRSII-CSECUR-30032">Overview</a>
</li>
<li>
<a href="develop98.html#HDRSII-CSECUR-36127">Enabling User Authentication</a>
</li>
<li>
<a href="develop99.html#HDRSII-CSECUR-37817">Defining Users</a>
</li>
<li>
<a href="develop100.html#HDRSII-CSECUR-38522">External Directory Service</a>
</li>
<li>
<a href="develop101.html#HDRSII-CSECUR-21547">Built-in Derby Users</a>
</li>
<li>
<a href="develop102.html#HDRSII-CSECUR-32557">Properties Summary</a>
</li>
<li>
<a href="develop103.html#HDRSII-CSECUR-79358">Programming Applications for Derby User Authentication</a>
</li>
</ul>
</li>
<li>
<a href="develop104.html#HDRSII-CSECUR-37241">Users and Authorization Identifiers</a> 
<ul>
<li>
<a href="develop105.html#HDRSII-CSECUR-24458">Authorization Identifiers, User Authentication, and User Authorization</a>
</li>
<li>
<a href="develop106.html#HDRCSECUR865580">User Names and Schemas</a>
</li>
<li>
<a href="develop107.html#HDRCSECUR865622">Exceptions</a>
</li>
</ul>
</li>
<li>
<a href="develop108.html#HDRSII-CSECUR-36595">User Authorization</a> 
<ul>
<li>
<a href="develop109.html#HDRCSECUR866060">Setting User Authorization</a>
</li>
<li>
<a href="develop110.html#HDRCSECUR866190">About Read-Only and Full Access</a>
</li>
<li>
<a href="develop111.html#HDRSII-CSECUR-79131">Examples</a>
</li>
</ul>
</li>
<li>
<a href="develop112.html#HDRSII-CSECUR-24366">Encrypting Databases on Disk</a> 
<ul>
<li>
<a href="develop113.html#HDRSII-CSECUR-99212">Overview</a>
</li>
<li>
<a href="develop114.html#HDRSII-CSECUR-96815">Requirements for Derby Encryption</a>
</li>
<li>
<a href="develop115.html#HDRSII-CSECUR-97760">Working with Encryption</a>
</li>
</ul>
</li>
<li>
<a href="develop116.html#HDRSII-CSECUR-90988">Signed Jar Files</a>
</li>
<li>
<a href="develop117.html#HDRSII-CSECUR-10983">Notes on the Derby Security Features</a>
</li>
<li>
<a href="develop118.html#HDRSII-CSECUR-51876">User Authentication and Authorization Examples</a> 
<ul>
<li>
<a href="develop119.html#HDRSII-CSECUR-18108">Client/Server Environment</a>
</li>
<li>
<a href="develop120.html#HDRSII-CSECUR-13713">Single-User, Embedded Environment</a>
</li>
</ul>
</li>
<li>
<a href="develop121.html#HDRBABEJDFJ">Running Derby under a security manager</a> 
<ul>
<li>
<a href="develop122.html#HDRBABEJGJD">Granting Permissions to Derby</a>
</li>
<li>
<a href="develop123.html#HDRCSECUR871387">Examples of Java 2 Security Policy Files for embedded Derby</a>
</li>
</ul>
</li>
</ul>
<p>
<a href="develop124.html#HDRSII-ADVJDBC-35053">Developing Tools and Using Derby with an IDE</a>
<br>
</p>
<ul>
<li>
<a href="develop125.html#HDRSII-ADVJDBC-41138">Offering Connection Choices to the User</a> 
<ul>
<li>
<a href="develop126.html#HDRADVJDBC814034">The DriverPropertyInfo Array</a>
</li>
</ul>
</li>
<li>
<a href="develop127.html#HDRSII-ADVJDBC-32436">Using Derby with IDEs</a> 
<ul>
<li>
<a href="develop128.html#HDRSII-ADVJDBC-18939">IDEs and Multiple JVMs</a>
</li>
</ul>
</li>
</ul>
<p>
<a href="develop129.html#HDRSII-TRICKS-32436">SQL Tips</a>
<br>
</p>
<ul>
<li>
<a href="develop130.html#HDRSII-TRICKS-19707">Retrieving the Database Connection URL</a>
</li>
<li>
<a href="develop131.html#HDRSII-TRICKS-39584">Supplying a Parameter Only Once</a>
</li>
<li>
<a href="develop132.html#HDRSII-TRICKS-21248">Defining an Identity Column</a>
</li>
<li>
<a href="develop133.html#HDRSII-TRICKS-23426">Using Third-Party Tools</a>
</li>
<li>
<a href="develop134.html#HDRSII-TRICKS-13019">Tricks of the VALUES Clause</a> 
<ul>
<li>
<a href="develop135.html#HDRTRICKS807337">Multiple Rows</a>
</li>
<li>
<a href="develop136.html#HDRTRICKS807365">Mapping Column Values to Return Values</a>
</li>
<li>
<a href="develop137.html#HDRTRICKS807400">Creating Empty Queries</a>
</li>
</ul>
</li>
</ul>
<p>
<a href="develop138.html#HDRSII-I18N-10613">Localizing Derby</a>
<br>
</p>
<ul>
<li>
<a href="develop139.html#HDRSII-I18N-71274">SQL Parser Support for Unicode</a>
</li>
</ul>
<p>
<a href="develop140.html#HDRSTNDRDS806118">Derby and Standards</a>
<br>
</p>
<ul>
<li>
<a href="develop141.html#HDRSTNDRDS806055">SQL99</a> 
<ul>
<li>
<a href="develop142.html#HDRSTNDRDS805644">Dynamic SQL</a>
</li>
<li>
<a href="develop143.html#HDRSTNDRDS805664">Cursors</a>
</li>
<li>
<a href="develop144.html#HDRSTNDRDS805690">Information Schema</a>
</li>
<li>
<a href="develop145.html#HDRSTNDRDS805716">Transactions</a>
</li>
<li>
<a href="develop146.html#HDRSTNDRDS805742">Stored routines and PSM</a>
</li>
<li>
<a href="develop147.html#HDRSTNDRDS805768">Calling functions and procedures</a>
</li>
<li>
<a href="develop148.html#HDRSTNDRDS805841">Unique constraints and nulls</a>
</li>
<li>
<a href="develop149.html#HDRSTNDRDS805893">NOT NULL characteristic</a>
</li>
<li>
<a href="develop150.html#HDRSTNDRDS805921">Fewer reserved keywords</a>
</li>
<li>
<a href="develop151.html#HDRSTNDRDS805949">DECIMAL max precision</a>
</li>
<li>
<a href="develop152.html#HDRSTNDRDS805975">CLOB, and BLOB</a>
</li>
<li>
<a href="develop153.html#HDRSTNDRDS806001">Expressions on LONGs</a>
</li>
<li>
<a href="develop154.html#HDRSTNDRDS806027">ALTER TABLE</a>
</li>
</ul>
</li>
</ul>
<p>
<a href="develop156.html#HDRTRADEM">Trademarks</a>
</p>
<p>
<a href="develop157.html#HDRINDEX_START">Index</a>
<br>
</p>
<hr>
<a href="develop.html">Previous Page</a>
<br>
<a href="develop03.html">Next Page</a>
<br>
<a href="#ToC">Table of Contents</a>
<br>
<a href="develop157.html#HDRINDEX_START">Index</a>
</div>
<div class="attribution"></div>
</div>
</td><td width="10"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<!--================= end Content==================-->
</table>
</td>
</tr>
</table>
<!--================= end Menu, NavBar, Content ==================-->
<!--================= start Footer ==================-->
<table summary="footer" cellspacing="0" cellpadding="0" width="100%" border="0">
<tr>
<td colspan="2" height="1" bgcolor="#4C6C8F"><img height="1" width="1" alt="" src="../../skin/images/spacer.gif" class="spacer"><a href="../../skin/images/label.gif"></a><a href="../../skin/images/page.gif"></a><a href="../../skin/images/chapter.gif"></a><a href="../../skin/images/chapter_open.gif"></a><a href="../../skin/images/current.gif"></a><a href="/favicon.ico"></a></td>
</tr>
<tr>
<td colspan="2" bgcolor="#CFDCED" class="copyright" align="center"><font size="2" face="Arial, Helvetica, Sans-Serif">Copyright &copy;
          2004&nbsp;Apache Software Foundation All rights reserved.<script type="text/javascript" language="JavaScript"><!--
              document.write(" - "+"Last Published: " + document.lastModified);
            //  --></script></font></td>
</tr>
<tr>
<td colspan="2" align="left" bgcolor="#CFDCED" class="logos"></td>
</tr>
</table>
<!--================= end Footer ==================-->
</body>
</html>
